SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001912s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508813 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508813 [ RunTime:0.003911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111525,314233,341987,339959,472696,1010691,120549,991176,61485,949539,236781,117185,699785,940480,97648,53023,308832,422616,243113,245604,501452,769862,1017929,380064,818121,500595,360617,208582,214274,809576,787745,220758,394917,329026,652794,199535,309952,903822,858755,961658,175496,670680,147217,160291,868692,487711,1029272,255300,701481,280074,121136,475060,534623,380161,797196,959037,790171,273177,865202,372621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]