SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 184508 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 184508 [ RunTime:0.001978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100243,321855,315147,409000,189692,135826,623806,760483,982551,381356,570024,166755,228555,898253,989133,817478,499515,740664,638966,850404,586339,546510,813391,359565,389735,576799,77658,936696,296555,600568,109765,477312,680753,401821,201989,122028,998764,824964,679542,437188,338086,869583,915890,598344,387291,955593,569352,812846,1032257,722785,45669,827960,955702,95374,208864,442198,342776,434267,512534,77552) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 184508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 184508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000778s ]