SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 140781 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 140781 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421653,210111,330571,575375,513606,958546,3588,919608,233565,1040163,844687,479124,691327,669692,1008650,296040,816679,774984,435516,656171,334324,1033050,744504,720029,37959,635503,979537,144213,78643,627519,906196,227739,171547,223021,204341,154118,359252,469159,174261,247487,980595,883584,315485,370744,117712,510906,895466,571999,454217,916575,665204,649821,515590,717329,934053,918172,251619,857794,662838,53963) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 140781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 140781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]