SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59640 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59640 [ RunTime:0.002918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106053,789679,878562,313770,148192,694386,413429,968774,81984,991714,488758,645663,486984,357620,696868,548878,278114,584205,527705,540838,590977,312019,836596,885214,901768,907161,364270,660870,589955,439013,387651,633913,588085,466014,30688,567337,870249,814398,535005,309499,757333,702732,969568,921727,404497,404788,872375,449266,678242,516627,336995,470019,516484,901997,900136,587017,441206,495934,80098,945340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]