SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000280 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000280 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255646,667878,519783,128413,768376,1025456,508844,170545,695412,41134,677302,968182,477961,875785,481509,224198,155372,31532,554123,175444,24046,777060,916606,905787,475213,534479,576407,559843,1004488,847577,250131,211515,588935,748075,503784,602759,251181,1035687,470394,85539,80984,1034511,539137,781198,797194,824979,100368,7986,768460,686206,729180,808986,942064,466444,1007346,339644,606925,185762,564662,499095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]