SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530905 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530905 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607599,899445,173876,866612,61500,801650,14486,388826,241552,495716,170543,400156,706920,735995,217168,113214,898822,954218,672826,210178,46639,503946,495236,651872,343542,560669,79225,955374,643684,190809,46202,1010769,755582,917450,84410,376200,705358,188259,659184,103488,714828,360609,737381,597270,550968,767784,648014,208688,48840,430154,216544,48881,1009479,63278,821845,387565,638860,49099,1989,306055) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]