SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002748s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570803 LIMIT 1 [ RunTime:0.000950s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570803 [ RunTime:0.004587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665031,561111,811707,72344,798826,563662,314860,228814,176031,200009,364043,844442,996773,345710,229622,766816,137026,822748,1029277,72529,330240,546711,540039,745026,843667,402747,958530,151139,540710,133163,1018373,148803,907530,680520,230441,542024,519982,69912,255323,65489,780581,126478,486537,136279,802024,928895,190079,256516,11163,524043,754183,837861,227738,1014573,275202,911525,771680,342685,1013683,31295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]