SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501154 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501154 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (651986,922799,659552,636127,630463,798407,496200,433584,232036,625357,754105,879980,399667,505612,366942,468862,373268,1041012,760020,281357,1033989,1036403,415519,94424,770240,312494,138772,100032,238789,610231,749859,716966,816932,568156,111481,962529,121035,919449,104142,696382,296806,834838,197119,545965,539265,968798,720857,47119,919633,871566,8329,755771,614353,818248,472447,721665,353127,547727,372569,641979) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501154 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501154 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]