SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196893 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196893 [ RunTime:0.001228s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693577,698510,964962,554102,357447,471989,669116,360111,340247,895538,502184,816580,140098,837923,216768,24753,394347,475843,891293,382355,2772,507990,905479,106470,335614,550930,433282,995507,482991,988977,898507,468680,247666,46996,754658,480376,293427,433466,218927,319047,676482,129370,384790,714690,627031,528762,21003,925187,655419,433201,62186,331480,800063,140470,690578,20312,479358,933743,540839,343790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]