SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50561 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50561 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (895033,969594,926895,195740,322767,441743,277579,406988,942644,213970,792648,788334,758359,952434,194785,658528,926239,339582,217717,24571,925787,970856,157547,278873,184610,164949,277052,181820,697159,754417,770087,443706,829437,264415,601905,542581,963827,718182,464580,408336,851472,521639,717987,304763,526027,900261,287677,750691,110023,303065,706101,531458,311016,931704,913251,124755,928782,823630,39239,405775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50561 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50561 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001550s ]