SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504987 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504987 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (687650,738232,490979,300430,594151,1038600,912102,69165,333023,777765,576380,253875,38176,868678,244563,746106,995742,240263,730994,314980,60592,744848,278057,550288,978244,300348,218786,966593,211187,90373,335432,882048,40620,717787,460553,723927,662815,211162,346835,214739,135186,879498,8173,198438,255642,467118,425977,748748,271591,625024,65979,355520,93751,1048201,685515,475441,1014904,522829,686924,1032800) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]