SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501602 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501602 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591856,561167,387043,1032596,755453,619769,737220,626334,705609,624249,886181,542137,142701,727882,302353,817371,641618,310461,118032,997307,552210,1041170,492578,997478,233275,564237,1016578,311576,189451,303879,536038,664105,104497,18031,931552,300247,561579,28044,373219,706132,237112,917276,664357,980971,597048,150302,154456,835861,724174,613652,1047304,11216,1021598,718841,1010708,283555,827461,475148,268697,433446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501602 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501602 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001528s ]