SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 354501 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 354501 [ RunTime:0.003183s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (952811,86700,530068,106843,120657,17788,830373,1045641,476312,985082,309724,238846,822513,448970,476847,919349,883155,424148,52001,543046,349857,819007,353221,302719,754767,9496,130471,822120,595528,573837,213141,715742,1042184,381865,357118,541237,93596,713340,1020188,407607,965936,737366,852567,526818,698986,637739,924677,34041,505449,712294,257670,161919,464323,315638,579155,454722,234769,452712,653956,209648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 354501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 354501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]