SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 143528 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 143528 [ RunTime:0.002046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17899,889974,310740,877834,809455,750986,180342,774246,201845,979295,150898,762727,1025576,571573,289150,355294,632783,351194,199569,145666,317491,734092,604902,435413,479060,27462,789432,1023963,446825,790984,876763,558044,474970,230993,617421,1041432,903705,83816,232610,413319,1032435,565145,1004491,958438,743082,695010,365518,516154,952144,382724,163824,118436,420159,803333,227949,276332,465480,211793,210441,700198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 143528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 143528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]