SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 55135 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 55135 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505309,196846,994573,117608,743691,381568,390420,42773,734832,782702,273176,453172,337030,117481,52564,802372,500103,233274,639344,742244,852895,42393,730047,633608,393200,191348,106076,72258,921298,959561,819355,136165,83786,1017875,350380,535672,250494,777597,235190,998267,267996,760157,645992,748119,641795,181633,179217,828674,536139,208988,913345,915772,176212,1044665,618540,371490,420285,600007,117327,748414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 55135 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 55135 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]