SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408001 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408001 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964510,996998,209025,1023551,743763,520298,674887,462597,44841,729179,876836,574213,1033212,387135,346377,191693,934148,481031,681700,489928,1026554,497222,982541,585649,948191,5153,927977,1002483,320778,691602,52042,787123,596803,753219,62165,383465,979599,458185,1027268,461561,705118,153044,64856,872061,734040,363727,431754,623922,63733,395744,170955,104119,726653,751076,489673,221234,325444,471125,20643,745408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]