SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002052s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435083 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435083 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (94341,128230,486362,981827,933342,759785,1006435,741287,106483,503542,533263,498340,242632,257255,188096,763966,960091,845953,3714,491112,458174,440889,307773,821643,129778,274149,923473,983853,27164,598618,891465,946580,856190,968861,459440,1048818,127028,489007,307510,930065,827442,667842,868661,1048512,769965,210885,968027,746575,1047043,780830,186554,87027,259464,377868,291662,542383,488404,458003,190779,832879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000702s ]