SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405578 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405578 [ RunTime:0.002877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (662337,111557,421507,71125,516069,987735,363223,1046135,754087,712220,101711,683313,747168,635141,733256,308173,433236,567577,212686,982517,611103,310839,355549,783279,22926,846512,907751,355408,103904,819438,132418,123352,992203,184874,982814,766667,343501,410851,677577,731729,881470,982792,368922,745027,943411,411150,421000,63355,11952,702940,817714,204246,642933,126444,978077,722938,161467,259943,911186,359842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]