SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149509 LIMIT 1 [ RunTime:0.000879s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149509 [ RunTime:0.001985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31545,979703,608369,669594,959541,1032421,919747,713888,974108,484279,624183,12613,708291,80824,259284,465753,1014795,95845,180759,367970,38556,598788,433809,136539,139033,22359,860354,118538,412917,965595,110332,684577,481530,838785,410687,699324,251739,614659,351772,151267,427878,237929,1015607,75111,992954,107005,215083,441377,723572,982970,178654,407117,350400,26519,1004483,433261,518516,698528,490168,558236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]