SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537236 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537236 [ RunTime:0.002169s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415309,895091,14152,1000698,246828,604292,626204,115074,501122,404759,802936,302760,330519,72916,42731,154497,160594,815763,451749,208236,19541,301114,164575,102042,506512,610242,649855,75453,460517,702540,871260,590717,255794,861001,635537,266031,734111,544096,963859,949477,682639,350886,891083,687572,19710,241826,750048,898617,260198,569275,968060,180473,423573,33625,946988,896546,84523,757114,603190,592388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]