SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468268 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468268 [ RunTime:0.003051s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538021,181353,321231,991073,7198,127917,1005402,662499,79501,716457,358554,521997,501893,953489,316930,303657,661107,814354,813478,881052,196210,763416,983072,977499,681411,612390,435347,192829,195828,335944,449125,920674,243191,955867,832383,674736,65068,383539,514252,304103,833228,690834,844605,639745,995640,313165,651043,548783,612860,33022,8640,921902,720226,897657,97462,981718,483855,343149,599924,401934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468268 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468268 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003772s ]