SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249612 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249612 [ RunTime:0.001909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502191,565523,1020133,380534,449637,398358,980706,815522,787133,50021,804497,447827,513578,176621,357248,346203,123421,618571,1002570,523722,484416,179581,105297,572018,797519,460274,284396,607770,635669,253042,121731,272613,141914,1025690,36956,254224,594505,120939,210401,607558,568117,870312,452281,606075,396254,1047090,588669,172642,1038071,355803,722516,149823,759769,542709,96829,55064,1043377,252356,1035555,1029882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000794s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]