SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501069 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501069 [ RunTime:0.003863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027156,398297,214984,662006,460466,13613,87134,368134,260190,579537,671391,662326,533255,111979,64641,23982,1010252,627094,898788,882994,627593,278488,434856,145991,210093,317856,125936,353872,860798,676745,20773,719733,278494,991609,261444,1030947,667146,542943,201623,427467,25476,320931,570319,736892,78185,399076,85107,215853,353796,527850,520495,252002,673268,369254,1403,250227,764328,957656,829464,429312) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501069 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501069 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]