SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568343 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568343 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845562,971716,419239,737403,21433,601899,677289,719791,998016,860798,179076,36402,722659,1012683,748829,440386,374320,997241,1042156,215708,346291,677711,493135,541023,42199,22803,357722,95688,523944,346886,562917,44030,641110,410045,1031041,226442,654433,86873,299486,446798,664991,309500,186605,843982,849905,877559,575903,875367,594076,91784,966577,616725,65691,339071,228182,1043354,379390,118544,476896,657172) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]