SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596585 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596585 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476237,189122,817023,363013,323000,788446,2196,431815,761285,633217,205552,1022364,953067,6216,416562,511138,270618,507199,266869,709702,151474,1037833,160959,391492,898044,322012,226548,226183,502763,494061,703759,939514,115843,986065,264327,879866,863034,51085,841659,579947,1003463,88662,534774,472981,323573,480016,996902,314310,274076,22239,414596,650043,1044699,898867,227118,801218,47432,929639,352226,265094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596585 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596585 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001329s ]