SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541905 LIMIT 1 [ RunTime:0.001732s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541905 [ RunTime:0.002203s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200959,265402,960771,508129,932517,398099,911942,613596,576395,389504,207268,188605,615784,145814,869555,1021824,826802,269771,502996,988481,889720,308665,354641,482911,794452,735343,374737,187697,1027196,457656,162336,908875,803436,561362,568152,480548,93043,456529,129778,190168,449519,334490,251452,701017,616333,20833,236691,195108,116274,1002080,249508,95390,355299,185938,952600,154334,549980,333591,817911,589803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]