SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861998 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861998 [ RunTime:0.002499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (773518,477513,964273,59398,311358,188886,219352,656883,447885,78686,343656,528642,75939,909226,858115,1036482,496882,494231,315925,280978,618138,375872,231928,483586,740079,125166,493241,448264,821938,752044,529898,259887,245418,780657,464139,743200,226832,495834,984316,1007723,525819,218365,1027450,798149,547144,88631,803105,322131,513325,1006990,417112,568405,322418,341472,277126,502697,828523,566691,77416,470151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000859s ]