SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410935 LIMIT 1 [ RunTime:0.002221s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410935 [ RunTime:0.006032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (883010,342821,753760,78549,718685,409507,554945,641577,178042,221438,411359,173491,791027,102652,500197,233595,317936,174874,683091,511904,804894,77677,900755,868596,302180,399447,773010,556997,191986,572357,24535,530690,580961,1001007,490317,995519,519191,336888,621606,677064,363031,411809,487706,922610,985575,413386,179843,103504,18509,877401,115386,127063,1017415,246665,575776,91461,892417,210127,874503,949917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410935 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000650s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410935 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]