SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001636s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435540 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435540 [ RunTime:0.003462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256768,139167,996929,439872,777345,625329,252260,516522,863731,252225,561622,314729,453915,1042754,372490,557840,107316,680277,433202,291780,941657,65349,95597,859089,352545,678157,943014,182813,504735,517829,697696,188265,112232,732421,678864,180073,348140,697217,274395,856189,202895,249660,131182,1037073,449837,482233,981483,398109,910897,292535,112592,329348,978572,1030771,731402,422416,218025,937256,72567,22627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]