SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535371 LIMIT 1 [ RunTime:0.000997s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535371 [ RunTime:0.002132s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514567,852661,739845,777779,474785,125408,959761,43567,654778,334342,434287,329047,397217,1012965,943156,456201,324385,1000512,17576,788435,537596,909556,1010118,318811,460775,934684,288857,862934,361322,1011868,730227,102593,298431,1014446,451222,796622,894205,784697,216283,42720,418877,209955,974428,578740,473236,334547,551639,361929,960568,764645,999588,166411,640059,215146,757531,571703,462806,983904,768843,496521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535371 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535371 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]