SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001507s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533436 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533436 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623789,815085,1039687,229877,301020,476243,534734,497238,451751,560195,805899,571263,463801,512306,32668,859952,1004342,438597,766187,176199,781820,1010380,277205,785587,731843,960810,834957,564920,180240,424178,986360,15474,111274,882981,269746,431202,184589,432242,436580,484141,1009376,126951,261274,805140,917812,591399,628359,482361,526690,402011,459060,947063,777562,541808,1018517,472996,517822,100538,418319,581150) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]