SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503999 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503999 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71423,681863,1017917,537280,300116,778656,417339,242645,768079,78686,645190,39307,900756,257319,106385,517364,770772,830832,334167,178295,700424,816886,890967,4884,884876,900497,318937,221705,473428,470886,772983,703714,237902,896700,798631,236353,744360,513984,676572,152003,108853,936779,156122,964793,745329,471878,797813,132813,513015,102162,208920,221634,332734,343827,352618,824410,588535,537592,832324,1009663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503999 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000890s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503999 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]