SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 188053 LIMIT 1 [ RunTime:0.000483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 188053 [ RunTime:0.002700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024438,131140,363654,320714,85788,801908,376252,448050,713448,454118,521433,254443,649183,208330,437003,11667,481226,308903,999719,219471,604038,1029656,427505,700705,2366,67511,383219,850452,84912,499583,186873,598670,784777,346774,407409,98228,815844,17009,539132,346243,485789,166129,363420,30509,804179,858327,575860,635325,990305,156152,1037287,678587,596764,382119,76555,189494,806795,570437,404391,501441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 188053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 188053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]