SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004709s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047723 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047723 [ RunTime:0.003614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (655718,837120,680889,632930,559025,353500,525818,281541,777441,567180,572538,468074,94804,358860,342821,70248,609059,179415,195364,232971,266435,210201,644351,610928,3132,58184,39868,178606,683160,25579,595069,736826,362578,475867,351782,619053,1018759,503164,314859,276564,967509,570706,59652,835670,755134,294423,516329,609302,313497,567221,720177,280133,257239,15714,100380,435488,1007697,392498,314040,321133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006601s ]