SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 928908 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 928908 [ RunTime:0.005131s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617152,43417,330316,825494,983080,230226,131712,401260,712937,229030,110127,499020,958800,581884,590055,371246,1013558,330838,761971,53639,1000198,842718,848551,141104,605531,598123,509181,609579,937058,522740,723766,342238,810320,14085,916385,793929,1044336,749143,576234,680676,438167,396836,518118,254445,290880,937866,639127,252122,46704,465798,592620,476211,525833,1008298,547966,713338,727638,123703,278890,917260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 928908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 928908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000805s ]