SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319918 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319918 [ RunTime:0.002007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522953,364779,878931,53870,651476,235655,836617,47306,626058,651501,181541,361668,495176,622464,724593,784796,963711,944059,764469,901603,157607,275992,1045348,491334,761360,286329,268380,707912,430671,427108,659358,301838,892700,817454,101638,453759,487443,383172,624396,681066,293896,614078,171193,367421,680518,589401,733200,739620,434898,88938,155044,65777,891238,521613,527965,15781,720382,20872,596601,490967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]