SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002623s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034471 LIMIT 1 [ RunTime:0.003782s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034471 [ RunTime:0.005150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262477,327787,758825,437950,490289,627286,11114,30284,116891,146466,52775,477544,292720,747521,258205,116938,360498,921236,804832,308613,501805,312891,507344,1001192,305527,278489,947563,554462,619021,1015774,746004,197671,333677,757989,878571,711456,381541,947534,1014836,295841,469514,120482,621039,321404,186795,622098,587477,777056,484949,808877,372315,703228,399654,100433,222286,456861,586338,928430,174759,790943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]