SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520318 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520318 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988797,412634,662821,340533,424050,685306,907223,22974,833306,656473,470276,487350,961428,881326,930725,218288,799494,656500,1047427,285851,584680,450291,89790,577469,575881,985519,919815,854870,434489,178886,410624,1025750,558503,432120,461829,882497,681045,410090,55005,421645,69420,375156,403922,934604,289856,735759,455481,601007,213500,1034631,239916,261559,286412,186426,331227,1003840,510287,62933,1029872,682889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]