SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504729 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504729 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537232,514519,567370,476490,476330,264655,1007751,174864,495902,958800,369770,1024811,822980,791896,1006767,833533,770599,111196,856263,460377,122376,451150,30897,78854,733784,997911,2215,132402,683111,581022,593474,273961,108111,168048,396856,495927,826864,1010158,726636,404250,625837,573993,31804,976333,467603,98699,978646,41307,1040321,32422,60795,872922,424423,485984,160001,718050,123639,765039,637978,1011944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504729 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504729 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]