SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 352341 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 352341 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (649889,220930,196215,573647,698788,720313,685320,476887,338867,535179,285305,102619,969714,771901,66868,189080,109624,77030,121445,712582,813790,633997,326044,707710,988338,1009124,150639,228452,639811,60199,772855,563827,485584,993654,76273,279468,384407,659687,333614,635846,563544,72335,754093,427370,942542,147642,504367,825762,735439,487887,222013,349336,765218,995871,540263,566984,770891,45249,891271,408279) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 352341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 352341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001285s ]