SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417907 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417907 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (94641,148236,863818,851930,791233,517884,783583,710141,692144,816017,939236,910958,682209,624220,594102,797745,269490,164433,391543,579296,1022577,773326,583669,544581,133459,552585,39535,537122,937774,73163,567548,422330,63602,1017393,481531,512406,30671,244336,643801,650816,568709,13009,351317,134985,395706,359116,329458,411941,462962,731561,561967,345085,884952,566785,889799,130034,681273,453889,329299,710613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]