SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585823 LIMIT 1 [ RunTime:0.001139s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585823 [ RunTime:0.002149s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (2513,1005390,46208,320296,345903,774491,568686,868297,479157,184456,546125,94628,770994,482662,591976,823787,442447,373604,216103,176365,900488,984311,827542,884229,173055,177060,104250,864515,1037776,399500,578974,641151,854700,844432,1009038,856306,280612,402704,158646,170854,424577,472062,128406,542378,1008381,344539,68157,664663,1013900,770033,347044,287436,406680,712865,617900,988110,396065,268531,687212,678794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]