SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671718 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671718 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42715,232213,764349,956783,655484,648900,408685,402734,358690,531467,632621,564214,130347,161238,527749,633057,544900,871483,745439,76116,583,429804,222125,16753,520532,755009,764593,668837,736329,732956,3967,497552,126235,1023776,576443,576610,337804,964959,305201,468174,198800,542813,486980,990778,964674,479353,29056,94806,730310,586444,145079,871942,757338,634202,287168,921729,934475,808672,639238,828134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]