SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456943 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456943 [ RunTime:0.002169s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565208,553358,180489,605215,671930,500945,180795,645977,432926,149622,516540,140799,341369,858096,917161,899323,356660,741374,836543,321421,668583,463541,302463,642431,557596,615746,878045,87113,519613,509849,487944,23696,1036431,750573,775048,875985,221868,54931,305779,520590,417203,579825,366193,147438,978514,251077,904332,52320,579112,213627,116637,161628,251981,182191,571783,526095,582611,709465,469760,7320) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]