SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142801 LIMIT 1 [ RunTime:0.001202s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142801 [ RunTime:0.002274s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677905,371893,51354,907228,1000392,644043,807606,526379,718874,103905,1040344,613106,1278,831009,172939,231915,823494,466838,250087,44962,631658,496117,334317,258767,275038,417422,219256,228365,907631,711133,984202,952161,809320,317814,981116,954488,136560,1037565,96552,202863,441517,793472,558868,492907,14673,190824,1033206,26198,806903,231076,45801,190934,385728,586283,893849,982801,107949,562963,46909,133616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]