SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402090 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402090 [ RunTime:0.004943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527506,893996,773131,1031898,159866,438732,505018,244688,272535,465849,545599,809061,161918,775416,902782,1040827,844502,359727,63455,647471,768776,614848,310895,415430,123011,910349,955168,423958,454448,860815,727156,541170,809432,335756,41804,146645,403047,671793,469238,881900,524608,539671,308243,823513,166541,185016,288832,978790,606954,892827,334569,366711,767777,850200,552909,165745,358015,416490,176803,570611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]