SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001669s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500834 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500834 [ RunTime:0.003071s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451108,727675,534101,40265,561639,984060,87357,362106,567040,875919,88794,868432,599584,1011897,1015017,415906,919898,420655,752298,358614,562734,290136,458302,424676,168745,696850,623854,718931,675242,785000,110460,13078,972654,867910,246098,45073,393718,182012,920550,756659,182794,324715,406081,163594,404511,583689,345987,1026598,845464,968010,618521,837998,283110,566339,95528,422667,1022380,362338,32934,304567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]