SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283054 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283054 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271213,746418,702726,189528,347003,182196,723452,1020068,928507,556312,518362,504582,937074,747927,923851,680302,1042962,1040381,619107,531113,928268,520249,337671,331294,675994,412488,671251,970825,108431,885817,939345,741076,55502,287959,350034,529187,637398,26692,469965,768305,509610,30151,802480,427269,884473,915178,230556,182152,874272,312520,986030,804352,720462,839305,450959,773549,482332,965667,697453,56741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]