SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406718 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406718 [ RunTime:0.001443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (896829,361474,790859,567740,1003876,623318,375928,819699,387604,519513,429217,621894,653611,324163,180029,84770,515073,279288,168368,453032,697585,308941,712524,780289,788193,942171,818957,40476,538956,434306,136875,200686,80168,865461,735145,439987,606863,1011240,107328,1412,986376,988381,782770,740456,772628,196036,98814,526306,148195,752933,249960,380671,720796,632524,620502,968194,1014667,910238,837156,545012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]