SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002414s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490083 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490083 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483898,91985,1026732,803306,955092,536434,971329,1015939,6348,1045437,658089,239338,968765,22006,562288,128458,456175,817648,145845,502643,236794,678019,26560,1000690,999371,879878,568499,50823,988941,797743,987547,695708,343606,188380,114691,443838,598688,605426,1020704,393995,846409,590533,602773,439896,127901,741109,428000,179109,550230,373353,191977,790685,42389,576709,344718,59753,1046802,559024,632717,787162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003725s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]