SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022974 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022974 [ RunTime:0.001510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394318,668771,128851,984411,155949,137293,685520,339332,542839,568462,987318,521365,803509,486908,933034,176225,825569,981457,3833,59457,408848,264332,798360,570076,595167,428506,251489,131746,202611,156695,543085,77754,487700,942768,839342,854516,955129,427543,1016829,290364,29463,860354,426326,444564,617770,952530,451784,922371,509699,702262,446228,476732,381803,157690,49043,862826,670646,832050,991188,630246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]