SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477724 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477724 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407411,541501,452834,782022,448027,241057,421143,982632,642149,472369,990947,180142,95297,355591,323755,948919,384753,19090,1032766,875998,826341,377042,777086,978767,2443,168555,830317,147702,912337,735655,15034,17537,770341,1039378,284749,940569,108314,1021017,268787,271049,485219,534916,686090,185687,288694,624956,355509,468555,818596,123893,277141,767180,280185,532328,915495,203818,218253,49342,897298,925265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477724 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477724 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]