SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398891 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398891 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424899,657072,741942,111413,614925,125849,511502,468813,360967,843415,429400,1001965,157112,496375,221751,132533,667642,150058,709234,924665,404766,539041,798751,996930,907023,146076,643476,215436,746790,678911,621337,868932,638446,773973,617151,550558,664039,289402,725010,983652,848754,937606,873747,1000749,66465,73482,494012,212849,717639,869896,851572,569347,659782,49000,44265,363849,570422,973426,651618,247908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]