SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456030 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456030 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231020,672546,315366,168977,546398,548621,971091,5543,998751,791635,490207,451915,194708,222054,873555,605463,115791,954306,126843,21802,308204,534430,593152,531203,834797,377408,668877,459847,745956,78239,535011,892306,685576,572145,583130,602002,1023004,346738,590052,590248,614906,233047,201139,568271,120383,801269,694226,275024,631563,433023,914221,210297,462829,687427,729055,503480,990640,298373,426670,518747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]