SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311410 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311410 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (290480,214884,295169,551302,504623,502529,126379,476071,723674,376533,581242,52819,1013271,48375,478115,692268,921335,968634,288878,60095,894734,970189,671720,379173,657732,875679,584621,997602,501496,57829,1042414,216484,474533,413825,589934,89559,1017192,721860,395200,983368,49441,621542,111284,954468,836814,697558,464430,696220,379462,232005,733469,969876,976410,770439,759713,1006384,1024787,559888,629986,171531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]