SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 322001 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 322001 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492588,26756,298819,22938,162241,728478,421961,107118,892247,118705,936026,805349,308388,250397,813372,431744,102996,233085,936954,306366,491201,1039668,664064,332343,425160,148198,293901,665198,369169,894925,91376,405347,1033882,221389,292432,541931,511484,545386,598054,903411,848956,936784,240849,221626,820588,190448,1028085,866655,14407,230599,989103,529719,861122,573493,140596,189981,893791,938361,444613,82991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 322001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 322001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]