SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503777 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503777 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128228,771238,996597,102972,6365,507180,437486,74324,944692,644799,792119,151632,725857,731516,916570,387641,354093,481024,708492,746738,99555,237540,414500,30838,891957,371913,393524,55438,904178,782199,124517,674405,1042930,641161,724405,847739,614851,391105,242134,919093,139693,647439,919508,708582,179599,136277,1047850,366645,1004293,686905,986188,273196,924993,354465,610940,503481,922306,761593,537062,843824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503777 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503777 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]