SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001629s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 187410 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 187410 [ RunTime:0.002496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18059,160068,558599,897368,754233,952954,924177,935456,77259,840751,377785,451560,301934,351022,803522,31999,52037,927440,288778,862515,458080,672538,760542,1002083,656854,733056,512442,913612,60636,399120,772190,703048,261285,911260,562420,403003,220199,559591,807019,896965,346254,785523,1018077,869336,755500,165020,399806,126947,50851,422283,707417,608554,177790,982643,925216,238930,181961,685892,950729,453777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 187410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 187410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]